OptionPositionRecordV5

V8 Message Definiton

OptionPositionRecords are live risk records that contain start-of-day positions and all subsequent executions, including executions reported as done away.\nThese records are published by a CoreRiskServer and represent the position and risk markup detail for a single option series.\nNew records are published immediately when a position changes and about once per minute if no position has changed.\nNote that all records for a single underlier are published simultaneously and records for the same chain should have consistent marks.

METADATA

Attribute	Value
Topic	4740-risk-v5
MLink Token	ClientRisk
Product	SRRisk
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
okey_at	enum - AssetType	PRI	'None'	ends with n if an MH allocation fraction n 1N MMH segment number
okey_ts	enum - TickerSrc	PRI	'None'	ends with n if an MH allocation fraction n 1N MMH segment number
okey_tk	VARCHAR(12)	PRI	''	ends with n if an MH allocation fraction n 1N MMH segment number
okey_yr	SMALLINT UNSIGNED	PRI	0	ends with n if an MH allocation fraction n 1N MMH segment number
okey_mn	TINYINT UNSIGNED	PRI	0	ends with n if an MH allocation fraction n 1N MMH segment number
okey_dy	TINYINT UNSIGNED	PRI	0	ends with n if an MH allocation fraction n 1N MMH segment number
okey_xx	DOUBLE	PRI	0	ends with n if an MH allocation fraction n 1N MMH segment number
okey_cp	enum - CallPut	PRI	'Call'	ends with n if an MH allocation fraction n 1N MMH segment number
accnt	VARCHAR(16)	PRI	''
tradeDate	DATE	PRI	'1900-01-01'
riskSession	enum - RiskSession	PRI	'Regular'
clientFirm	VARCHAR(16)	PRI	''	SR assigned client firm
riskServerCode	VARCHAR(6)		''
aggGroup	VARCHAR(16)		''	SR assigned agg group
fkey_at	enum - AssetType		'None'	underlying future if written on a future
fkey_ts	enum - TickerSrc		'None'	underlying future if written on a future
fkey_tk	VARCHAR(12)		''	underlying future if written on a future
fkey_yr	SMALLINT UNSIGNED		0	underlying future if written on a future
fkey_mn	TINYINT UNSIGNED		0	underlying future if written on a future
fkey_dy	TINYINT UNSIGNED		0	underlying future if written on a future
ticker_at	enum - AssetType		'None'	underlying ticker
ticker_ts	enum - TickerSrc		'None'	underlying ticker
ticker_tk	VARCHAR(12)		''	underlying ticker
exType	enum - ExerciseType		'None'
multihedge	enum - Multihedge		'None'
multihedgeSource_at	enum - AssetType		'None'	MH Ticker Key starts with if exists
multihedgeSource_ts	enum - TickerSrc		'None'	MH Ticker Key starts with if exists
multihedgeSource_tk	VARCHAR(12)		''	MH Ticker Key starts with if exists
multihedgePVRatio	FLOAT		0	pv multiplier fraction of underlier value uPerCn x uPrc SUMuPerCn x uPrc associated with this fragment
optionType	enum - OptionType		'None'
cashOnEx	FLOAT		0	cash on settlement multihedge
strikeRatio	FLOAT		0	strike ratio
uPrcRatio	FLOAT		0	stock price multiplier
underliersPerCn	INT		0	underliers per contract
underlierType	enum - UnderlierType		'None'	type of underlier affects greek calculations
tickValue	FLOAT		0	NLV value of a single tick change in display premium pointValue tickValue tickSize
pointValue	FLOAT		0	NLV value of a single point change in display premium pointValue tickValue tickSize
pointCurrency	enum - Currency		'None'
priceFormat	enum - PriceFormat		'None'	option price display format code
uPriceFormat	enum - PriceFormat		'None'	underlier price display format code
uPrc	DOUBLE		0	current underlier price any market session persists if market closedhalted
uBid	DOUBLE		0	current underlier bid any market session zero if market closedhalted
uAsk	DOUBLE		0	current underlier ask any market session zero if market closedhalted
uMark	DOUBLE		0	current underlier mark usually mid market freezes at SR CloseMarkTime
uMarkSource	enum - UMarkSource		'None'
optBid	FLOAT		0	current option market bid any market session zero if market closedhalted
optAsk	FLOAT		0	current option market ask any market session zero if market closedhalted
optMidMark	DOUBLE		0	current option mark mid market freezes at SR CloseMarkTime
optVolMark	DOUBLE		0	current option mark volatility surface freezes at SR CloseMarkTime
uOpnMark	DOUBLE		0	startofday SR underlier mark rotated from prior day record corp action adjusted
optOpnVolMark	DOUBLE		0	startofday SR vol mark corp action adjusted
optOpnMidMark	DOUBLE		0	startofday SR mid mark corp action adjusted
optOpnClrMark	DOUBLE		0	startofday clearing mark should be corp action adjusted
optOpnPosPrv	INT		0	startofday SR contract position rotated from prior day record corp action adjusted
optOpnPosClr	INT		0	startofday CKR contract position supplied by clientclearing firm via clearing position load should be corp action adjusted
optOpnPos	INT		0	start of period contract position effective can be from either CLR or SR
optOpnPosSrc	enum - PositionSource		'None'	start of period position source
cnBot	INT		0	number of contracts bot today
cnSld	INT		0	number of contracts sld today
cnOpened	INT		0	number of contracts opened today
cnClosed	INT		0	number of contracts closed today
edgeOpened	FLOAT		0	edge from opening trades model 1
edgeClosed	FLOAT		0	edge from closing trades model 1
trdDelta	FLOAT		0	deltas from trades fixed at the time of trade
trdGamma	FLOAT		0	gamma from trades fixed at the time of trade
trdDeltaMny	FLOAT		0	deltas x uPrc from trades fixed at the time of trade
optMnyBot	DOUBLE		0	sum of settle cash for all buy executions
optMnySld	DOUBLE		0	sum of settle cash for all sell executions
dayPnl	FLOAT		0
dnDayPnl	FLOAT		0
opnPnlMidMark	FLOAT		0
opnPnlVolMark	FLOAT		0
opnPnlClrMark	FLOAT		0
cnNetOpnPos	INT		0	opening position cnOpnPos net of reversalsconversions
cnNetCurPos	INT		0	current position cnOpnPos cnBot cnSld net of reversalsconversions
cnAtmEquiv	FLOAT		0	current position atm equivalent contracts cnNetPos ve atmVega
beta	FLOAT		0	beta usually beta to SPX see AccountConfigbetaSource
betaSource	enum - BetaSource		'None'
divDays	SMALLINT		0	days to the next dividend 0 exDate is today 1 exDate is yesterday
hedgeDeltaRule	enum - HedgeDeltaRule		'None'	HedgeDelta Source IVol use SR implied surface sticky strike IvS use SR surface sticky delta TVol use user supplied theo surface sticky strike TvS use user supplied theo surface and atm veSlope sticky delta AccountConfighedgeDelta
binaryDays	FLOAT		0	hedgeDelta 100500510 if less than binary days to expirationusually 00 20
days	SMALLINT		0	days to expiration
years	FLOAT		0	years to expiration
rate	FLOAT		0	global rate to expiration pricing
sdiv	FLOAT		0	continuous stock div pricing
ddiv	FLOAT		0	present value of discrete dividends pricing
dadj	FLOAT		0	dadj frational dividend value 10 except for some multihedge roots
atmVol	FLOAT		0	live surface atm volatility
atmVega	FLOAT		0	live surface atm vega
iVol	FLOAT		0	surface volatility
iVolSrc	enum - MarkSource		'None'
de	FLOAT	PRI	0	deltadOpx dUPrc
ga	FLOAT		0	gammadDelta dUPrc
th	FLOAT		0	thetadOpx dTime
ve	FLOAT		0	vegadOpx dVol
rh	FLOAT		0	rhodOpx dRate
ph	FLOAT		0	phidOpx dSDiv
vo	FLOAT		0	volga SR surface
va	FLOAT		0	vanna SR surface
deDecay	FLOAT		0	delta decay charm delta bleed dDeltadTime
err	TINYINT UNSIGNED		0	computation error code if any
veSlope	FLOAT		0	ivol correlation veSlope dVol dUPrc can be either SR surface veSlope or client theo veSlope
hedgeDe	FLOAT		0	hedge delta either ivol or tvol basedfollows binary rules
hedgeGa	FLOAT		0	hedge gamma either ivol or tvol basedfollows binary rules
srSlope	FLOAT		0	ivol correlation srSlope dVol dUPrc always SR surface veSlope
isBinary	enum - YesNo		'None'	hedge deltagamma has switched to binary
premOvPar	FLOAT		0	premium over parity for the option position
xde	FLOAT		0	xdelta C 05 de P 05 de
loBound	FLOAT		0	minimum noarb opx zero volatility given sdivddivyearsrate
su90	FLOAT		0	underlier up 90 sticky delta
sd90	FLOAT		0	underlier dn 90 sticky delta
su50	FLOAT		0	underlier up 50 sticky delta
sd50	FLOAT		0	underlier dn 50 sticky delta
su15	FLOAT		0	underlier up 15 sticky delta
sd15	FLOAT		0	underlier dn 15 sticky delta
su10	FLOAT		0	underlier up 10 sticky delta
sd10	FLOAT		0	underlier dn 10 sticky delta
su06	FLOAT		0	underlier up 6 sticky delta
sd08	FLOAT		0	underlier dn 8 sticky delta
su05	FLOAT		0	underlier up 5 sticky delta
sd05	FLOAT		0	underlier dn 5 sticky delta
su1e	FLOAT		0	underlier up 1x implied earn move vol ramp out deltaneutral
sd1e	FLOAT		0	underlier dn 1x implied earn move vol ramp out deltaneutral
su2e	FLOAT		0	underlier up 2x implied earn move vol ramp out deltaneutral
sd2e	FLOAT		0	underlier dn 2x implied earn move vol ramp out deltaneutral
earn	FLOAT		0	vol earn ramp out no underlier move
cash	FLOAT		0	underlier up 30 vol 010 6mn deal close
theoModel	VARCHAR(16)		''	theo model 1
tVol	FLOAT		0	theo volatility
tOpx	FLOAT		0	theo price
tBOpnPx	FLOAT		0	theo buyopen price
tSOpnPx	FLOAT		0	theo sellopen price
tBClsPx	FLOAT		0	theo buyclose price
tSClsPx	FLOAT		0	theo sellclose price
tDe	FLOAT		0	theo delta
tGa	FLOAT		0	theo gamma
tErr	TINYINT UNSIGNED		0	theo vol error code TheoError
theoModel2	VARCHAR(16)		''	theo model 2 used for edge markup
tVol2	FLOAT		0	theo volatility model 2
tOpx2	FLOAT		0	theo price model 2
tErr2	TINYINT UNSIGNED		0	theo vol error code model 2
yearsPr	FLOAT		0
ratePr	FLOAT		0
sdivPr	FLOAT		0
ddivPr	FLOAT		0
iVolPr	FLOAT		0	prior period surface volatility
dePr	FLOAT		0
gaPr	FLOAT		0
thPr	FLOAT		0
vePr	FLOAT		0
rhPr	FLOAT		0
phPr	FLOAT		0
voPr	FLOAT		0
vaPr	FLOAT		0
errPr	TINYINT UNSIGNED		0	prior period computation error code if any
veSlopePr	FLOAT		0	prior period veSlope
hedgeDePr	FLOAT		0	prior period hedge delta
tVolPr	FLOAT		0	prior period theo volatility theoModel
tOpxPr	FLOAT		0	prior period theo price
tDePr	FLOAT		0	prior period theo delta
tVolPr2	FLOAT		0	prior period theo volatility theoModel2
tOpxPr2	FLOAT		0	prior period theo price
tDePr2	FLOAT		0	prior period theo delta
xdePr	FLOAT		0
marginUDnVDn	FLOAT		0	Aggregate RiskSlide uPrc dn vol dn
marginUDnVUp	FLOAT		0	Aggregate RiskSlide uPrc dn vol up
marginUUpVDn	FLOAT		0	Aggregate RiskSlide uPrc up vol dn
marginUUpVUp	FLOAT		0	Aggregate RiskSlide uPrc up vol up
opnPnlDe	FLOAT		0	open position mult hedgeDe dUPrc
opnPnlGa	FLOAT		0	open position mult 05 optGamma dUPrc dUPrc
opnPnlTh	FLOAT		0	open position mult optTheta dTime
opnPnlVe	FLOAT		0	open position mult optVega dVol
opnPnlVo	FLOAT		0	open position mult 05 optVolga dVol dVol
opnPnlVa	FLOAT		0	open position mult optVanna dVol dUPrc
opnPnlSl	FLOAT		0	open position mult voluPrc slope optVega dUPrc
opnPnlRate	FLOAT		0	open position mult optRho dRate
opnPnlSDiv	FLOAT		0	open position mult optPhi dSDv
opnPnlDDiv	FLOAT		0	open position mult optPhi dDDv
opnPnlSv	FLOAT		0	open position mult SR Vol Pnl opnPnlDe
opnPnlErr	FLOAT		0	unattributed pnl SR Vol Pnl opnPnlDe opnPnlGa opnPnlTh opnPnlVe opnPnlRat opnPnlSDiv opnPnlDDiv
shBotC0	INT		0	hypothetical shares bot 1minute intervals
shSldC0	INT		0	hypothetical shares sld
shMnyC0	FLOAT		0	hypothetical money
shBotC1	INT		0	hypothetical shares bot 10minute intervals
shSldC1	INT		0	hypothetical shares sld
shMnyC1	FLOAT		0	hypothetical money
markErrCodes	VARCHAR(255)		'None'
exValue	FLOAT		0	early exercise value amLimit bsPrice
riskAlert	enum - AlertCode		'None'
numExecutions	INT		0	number of included SpdrParentExecution records
maxExecDttm	DATETIME(6)		'1900-01-01 00:00:00.000000'	maximum activity dttm of execution records included in this option risk summary
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
okey_tk	1
okey_yr	2
okey_mn	3
okey_dy	4
okey_xx	5
okey_cp	6
okey_at	7
okey_ts	8
accnt	9
tradeDate	10
riskSession	11
clientFirm	12

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRRisk`.`MsgOptionPositionRecordV5` (
    `okey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `okey_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'ends with ''$n'' if an MH allocation fraction (n = 1-N) [MMH segment number]',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `tradeDate` DATE NOT NULL DEFAULT '1900-01-01',
    `riskSession` ENUM('Regular','PostClose') NOT NULL DEFAULT 'Regular',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR assigned client firm',
    `riskServerCode` VARCHAR(6) NOT NULL DEFAULT '',
    `aggGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR assigned agg group',
    `fkey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'underlying future (if written on a future)',
    `fkey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'underlying future (if written on a future)',
    `fkey_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'underlying future (if written on a future)',
    `fkey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'underlying future (if written on a future)',
    `fkey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'underlying future (if written on a future)',
    `fkey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'underlying future (if written on a future)',
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'underlying ticker',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'underlying ticker',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'underlying ticker',
    `exType` ENUM('None','American','European','Asian','Cliquet') NOT NULL DEFAULT 'None',
    `multihedge` ENUM('None','Simple','Complex','AllCash','Binary','Fragment') NOT NULL DEFAULT 'None',
    `multihedgeSource_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'MH Ticker Key (starts with ''_'') (if exists)',
    `multihedgeSource_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'MH Ticker Key (starts with ''_'') (if exists)',
    `multihedgeSource_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'MH Ticker Key (starts with ''_'') (if exists)',
    `multihedgePVRatio` FLOAT NOT NULL DEFAULT 0 COMMENT 'pv multiplier (fraction of underlier value (uPerCn x uPrc) / SUM(uPerCn x uPrc) associated with this fragment',
    `optionType` ENUM('None','Equity','Index','Future','Binary','Warrant','Flex','MapError') NOT NULL DEFAULT 'None',
    `cashOnEx` FLOAT NOT NULL DEFAULT 0 COMMENT 'cash on settlement (multihedge)',
    `strikeRatio` FLOAT NOT NULL DEFAULT 0 COMMENT 'strike ratio',
    `uPrcRatio` FLOAT NOT NULL DEFAULT 0 COMMENT 'stock price multiplier',
    `underliersPerCn` INT NOT NULL DEFAULT 0 COMMENT 'underliers per contract',
    `underlierType` ENUM('None','Equity','Other','FX') NOT NULL DEFAULT 'None' COMMENT 'type of underlier (affects $greek calculations)',
    `tickValue` FLOAT NOT NULL DEFAULT 0 COMMENT '$NLV value of a single tick change in display premium	(pointValue = tickValue / tickSize)',
    `pointValue` FLOAT NOT NULL DEFAULT 0 COMMENT '$NLV value of a single point change in display premium (pointValue = tickValue / tickSize)',
    `pointCurrency` ENUM('None','AUD','BRL','CAD','CHF','CNH','CNY','EUR','GBP','JPY','KRW','MXN','MYR','NOK','NZD','SEK','TRY','USD','USDCents','CZK','ZAR','HUF','USX','GBX') NOT NULL DEFAULT 'None',
    `priceFormat` ENUM('None','N0','N1','N2','N3','N4','N5','N6','N7','F4','F8','Q8','F16','F32','H32','Q32','F64','H64','FullPenny','PartPenny','PartNickle','EQT','V1','V2','V3','V4','V5','V6','V7','V8','V9','V10','V11','V12','V13','V14','V15','A0','A1','A2','A3','A4','A5','A6','A7','E32') NOT NULL DEFAULT 'None' COMMENT 'option price display format code',
    `uPriceFormat` ENUM('None','N0','N1','N2','N3','N4','N5','N6','N7','F4','F8','Q8','F16','F32','H32','Q32','F64','H64','FullPenny','PartPenny','PartNickle','EQT','V1','V2','V3','V4','V5','V6','V7','V8','V9','V10','V11','V12','V13','V14','V15','A0','A1','A2','A3','A4','A5','A6','A7','E32') NOT NULL DEFAULT 'None' COMMENT 'underlier price display format code',
    `uPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current underlier price (any market session) (persists if market closed/halted)',
    `uBid` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current underlier bid (any market session) (zero if market closed/halted)',
    `uAsk` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current underlier ask (any market session) (zero if market closed/halted)',
    `uMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current underlier mark (usually mid market) (freezes at SR CloseMarkTime)',
    `uMarkSource` ENUM('None','OpenMark','CloseMark','Print','LiveQuote','QuoteBound') NOT NULL DEFAULT 'None',
    `optBid` FLOAT NOT NULL DEFAULT 0 COMMENT 'current option market bid (any market session) (zero if market closed/halted)',
    `optAsk` FLOAT NOT NULL DEFAULT 0 COMMENT 'current option market ask (any market session) (zero if market closed/halted)',
    `optMidMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current option mark (mid market) (freezes at SR CloseMarkTime)',
    `optVolMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'current option mark (volatility surface) (freezes at SR CloseMarkTime)',
    `uOpnMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'start-of-day SR underlier mark (rotated from prior day record) [corp action adjusted]',
    `optOpnVolMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'start-of-day SR vol mark [corp action adjusted]',
    `optOpnMidMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'start-of-day SR mid mark [corp action adjusted]',
    `optOpnClrMark` DOUBLE NOT NULL DEFAULT 0 COMMENT 'start-of-day clearing mark [should be corp action adjusted]',
    `optOpnPosPrv` INT NOT NULL DEFAULT 0 COMMENT 'start-of-day SR contract position (rotated from prior day record) [corp action adjusted]',
    `optOpnPosClr` INT NOT NULL DEFAULT 0 COMMENT 'start-of-day CKR contract position (supplied by client/clearing firm via clearing position load) [should be corp action adjusted]',
    `optOpnPos` INT NOT NULL DEFAULT 0 COMMENT 'start of period contract position (effective; can be from either CLR or SR)',
    `optOpnPosSrc` ENUM('None','Zero','SR','CLR') NOT NULL DEFAULT 'None' COMMENT 'start of period position source',
    `cnBot` INT NOT NULL DEFAULT 0 COMMENT 'number of contracts bot today',
    `cnSld` INT NOT NULL DEFAULT 0 COMMENT 'number of contracts sld today',
    `cnOpened` INT NOT NULL DEFAULT 0 COMMENT 'number of contracts opened today',
    `cnClosed` INT NOT NULL DEFAULT 0 COMMENT 'number of contracts closed today',
    `edgeOpened` FLOAT NOT NULL DEFAULT 0 COMMENT 'edge from opening trades (model #1)',
    `edgeClosed` FLOAT NOT NULL DEFAULT 0 COMMENT 'edge from closing trades (model #1)',
    `trdDelta` FLOAT NOT NULL DEFAULT 0 COMMENT 'deltas from trades (fixed at the time of trade)',
    `trdGamma` FLOAT NOT NULL DEFAULT 0 COMMENT 'gamma from trades (fixed at the time of trade)',
    `trdDeltaMny` FLOAT NOT NULL DEFAULT 0 COMMENT 'deltas x uPrc from trades (fixed at the time of trade)',
    `optMnyBot` DOUBLE NOT NULL DEFAULT 0 COMMENT 'sum of settle cash for all buy executions',
    `optMnySld` DOUBLE NOT NULL DEFAULT 0 COMMENT 'sum of settle cash for all sell executions',
    `dayPnl` FLOAT NOT NULL DEFAULT 0,
    `dnDayPnl` FLOAT NOT NULL DEFAULT 0,
    `opnPnlMidMark` FLOAT NOT NULL DEFAULT 0,
    `opnPnlVolMark` FLOAT NOT NULL DEFAULT 0,
    `opnPnlClrMark` FLOAT NOT NULL DEFAULT 0,
    `cnNetOpnPos` INT NOT NULL DEFAULT 0 COMMENT 'opening position (cnOpnPos) net of reversals/conversions',
    `cnNetCurPos` INT NOT NULL DEFAULT 0 COMMENT 'current position (cnOpnPos + cnBot - cnSld) net of reversals/conversions',
    `cnAtmEquiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'current position (atm equivalent contracts: (cnNetPos * ve / atmVega)',
    `beta` FLOAT NOT NULL DEFAULT 0 COMMENT 'beta (usually beta to SPX; see AccountConfig.betaSource)',
    `betaSource` ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') NOT NULL DEFAULT 'None',
    `divDays` SMALLINT NOT NULL DEFAULT 0 COMMENT 'days to the next dividend (0 = exDate is today, -1 = exDate is yesterday)',
    `hedgeDeltaRule` ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') NOT NULL DEFAULT 'None' COMMENT 'HedgeDelta Source (IVol = use SR implied surface (sticky strike), IvS = use SR surface (sticky delta), TVol = use user supplied theo surface (sticky strike), TvS = use user supplied theo surface and atm veSlope (sticky delta)) [AccountConfig.hedgeDelta]',
    `binaryDays` FLOAT NOT NULL DEFAULT 0 COMMENT 'hedgeDelta = -1.0,-0.5,0,+0.5,+1.0 if less than binary days to expiration;usually [0.0 - 2.0]',
    `days` SMALLINT NOT NULL DEFAULT 0 COMMENT 'days to expiration',
    `years` FLOAT NOT NULL DEFAULT 0 COMMENT 'years to expiration',
    `rate` FLOAT NOT NULL DEFAULT 0 COMMENT 'global rate to expiration (pricing)',
    `sdiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'continuous stock div (pricing)',
    `ddiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'present value of discrete dividends (pricing)',
    `dadj` FLOAT NOT NULL DEFAULT 0 COMMENT 'dadj frational dividend value; 1.0 except for some multihedge roots',
    `atmVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'live surface atm volatility',
    `atmVega` FLOAT NOT NULL DEFAULT 0 COMMENT 'live surface atm vega',
    `iVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'surface volatility',
    `iVolSrc` ENUM('None','NbboMid','SRVol','LoBound','HiBound','Other') NOT NULL DEFAULT 'None',
    `de` FLOAT NOT NULL DEFAULT 0 COMMENT 'delta;(dOpx / dUPrc)',
    `ga` FLOAT NOT NULL DEFAULT 0 COMMENT 'gamma;(dDelta / dUPrc)',
    `th` FLOAT NOT NULL DEFAULT 0 COMMENT 'theta;(dOpx / dTime)',
    `ve` FLOAT NOT NULL DEFAULT 0 COMMENT 'vega;(dOpx / dVol)',
    `rh` FLOAT NOT NULL DEFAULT 0 COMMENT 'rho;(dOpx / dRate)',
    `ph` FLOAT NOT NULL DEFAULT 0 COMMENT 'phi;(dOpx / dSDiv)',
    `vo` FLOAT NOT NULL DEFAULT 0 COMMENT 'volga (SR surface)',
    `va` FLOAT NOT NULL DEFAULT 0 COMMENT 'vanna (SR surface)',
    `deDecay` FLOAT NOT NULL DEFAULT 0 COMMENT 'delta decay, charm, delta bleed; (dDelta/dTime)',
    `err` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'computation error code (if any)',
    `veSlope` FLOAT NOT NULL DEFAULT 0 COMMENT 'ivol correlation (veSlope = dVol / dUPrc) [can be either SR surface veSlope or client theo veSlope]',
    `hedgeDe` FLOAT NOT NULL DEFAULT 0 COMMENT 'hedge delta (either ivol or tvol based;follows binary rules)',
    `hedgeGa` FLOAT NOT NULL DEFAULT 0 COMMENT 'hedge gamma (either ivol or tvol based;follows binary rules)',
    `srSlope` FLOAT NOT NULL DEFAULT 0 COMMENT 'ivol correlation (srSlope = dVol / dUPrc) [always SR surface veSlope]',
    `isBinary` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'hedge delta/gamma has switched to ''binary''',
    `premOvPar` FLOAT NOT NULL DEFAULT 0 COMMENT 'premium over parity for the option position',
    `xde` FLOAT NOT NULL DEFAULT 0 COMMENT 'xdelta (C: +0.5 - de, P: -0.5 - de)',
    `loBound` FLOAT NOT NULL DEFAULT 0 COMMENT 'minimum no-arb opx (zero volatility given sdiv/ddiv/years/rate)',
    `su90` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 90%, sticky delta',
    `sd90` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 90%, sticky delta',
    `su50` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 50%, sticky delta',
    `sd50` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 50%, sticky delta',
    `su15` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 15%, sticky delta',
    `sd15` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 15%, sticky delta',
    `su10` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 10%, sticky delta',
    `sd10` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 10%, sticky delta',
    `su06` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 6%, sticky delta',
    `sd08` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 8%, sticky delta',
    `su05` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 5%, sticky delta',
    `sd05` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 5%, sticky delta',
    `su1e` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 1x implied earn move, vol ramp out, delta-neutral',
    `sd1e` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 1x implied earn move, vol ramp out, delta-neutral',
    `su2e` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 2x implied earn move, vol ramp out, delta-neutral',
    `sd2e` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier dn 2x implied earn move, vol ramp out, delta-neutral',
    `earn` FLOAT NOT NULL DEFAULT 0 COMMENT 'vol earn ramp out (no underlier move)',
    `cash` FLOAT NOT NULL DEFAULT 0 COMMENT 'underlier up 30%, vol = 0.10, 6mn deal close',
    `theoModel` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'theo model #1',
    `tVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo volatility',
    `tOpx` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo price',
    `tBOpnPx` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo buy/open price',
    `tSOpnPx` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo sell/open price',
    `tBClsPx` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo buy/close price',
    `tSClsPx` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo sell/close price',
    `tDe` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo delta',
    `tGa` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo gamma',
    `tErr` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'theo vol error code (TheoError)',
    `theoModel2` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'theo model #2 (used for edge markup)',
    `tVol2` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo volatility (model #2)',
    `tOpx2` FLOAT NOT NULL DEFAULT 0 COMMENT 'theo price (model #2)',
    `tErr2` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'theo vol error code (model #2)',
    `yearsPr` FLOAT NOT NULL DEFAULT 0,
    `ratePr` FLOAT NOT NULL DEFAULT 0,
    `sdivPr` FLOAT NOT NULL DEFAULT 0,
    `ddivPr` FLOAT NOT NULL DEFAULT 0,
    `iVolPr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period surface volatility',
    `dePr` FLOAT NOT NULL DEFAULT 0,
    `gaPr` FLOAT NOT NULL DEFAULT 0,
    `thPr` FLOAT NOT NULL DEFAULT 0,
    `vePr` FLOAT NOT NULL DEFAULT 0,
    `rhPr` FLOAT NOT NULL DEFAULT 0,
    `phPr` FLOAT NOT NULL DEFAULT 0,
    `voPr` FLOAT NOT NULL DEFAULT 0,
    `vaPr` FLOAT NOT NULL DEFAULT 0,
    `errPr` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'prior period computation error code (if any)',
    `veSlopePr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period veSlope',
    `hedgeDePr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period hedge delta',
    `tVolPr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo volatility (theoModel)',
    `tOpxPr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo price',
    `tDePr` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo delta',
    `tVolPr2` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo volatility (theoModel#2)',
    `tOpxPr2` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo price',
    `tDePr2` FLOAT NOT NULL DEFAULT 0 COMMENT 'prior period theo delta',
    `xdePr` FLOAT NOT NULL DEFAULT 0,
    `marginUDnVDn` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn, vol dn',
    `marginUDnVUp` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc dn, vol up',
    `marginUUpVDn` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up, vol dn',
    `marginUUpVUp` FLOAT NOT NULL DEFAULT 0 COMMENT 'Aggregate RiskSlide: uPrc up, vol up',
    `opnPnlDe` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * hedgeDe * dUPrc',
    `opnPnlGa` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * 0.5 * optGamma * dUPrc * dUPrc',
    `opnPnlTh` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optTheta * dTime',
    `opnPnlVe` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optVega * dVol',
    `opnPnlVo` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * 0.5 * optVolga * dVol * dVol',
    `opnPnlVa` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optVanna * dVol * dUPrc',
    `opnPnlSl` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * vol/uPrc * slope * optVega * dUPrc',
    `opnPnlRate` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optRho * dRate',
    `opnPnlSDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optPhi * dSDv',
    `opnPnlDDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * optPhi * dDDv',
    `opnPnlSv` FLOAT NOT NULL DEFAULT 0 COMMENT 'open position * mult * (SR Vol Pnl - opnPnlDe)',
    `opnPnlErr` FLOAT NOT NULL DEFAULT 0 COMMENT 'unattributed pnl: SR Vol Pnl - opnPnlDe - opnPnlGa - opnPnlTh - opnPnlVe - opnPnlRat - opnPnlSDiv - opnPnlDDiv',
    `shBotC0` INT NOT NULL DEFAULT 0 COMMENT 'hypothetical shares bot (~1/minute intervals)',
    `shSldC0` INT NOT NULL DEFAULT 0 COMMENT 'hypothetical shares sld',
    `shMnyC0` FLOAT NOT NULL DEFAULT 0 COMMENT 'hypothetical money',
    `shBotC1` INT NOT NULL DEFAULT 0 COMMENT 'hypothetical shares bot (~10/minute intervals)',
    `shSldC1` INT NOT NULL DEFAULT 0 COMMENT 'hypothetical shares sld',
    `shMnyC1` FLOAT NOT NULL DEFAULT 0 COMMENT 'hypothetical money',
    `markErrCodes` VARCHAR(255) NOT NULL DEFAULT 'None',
    `exValue` FLOAT NOT NULL DEFAULT 0 COMMENT 'early exercise value (amLimit - bsPrice)',
    `riskAlert` ENUM('None','ExerciseNow','ExBeforeNextDiv','ExAfterNextDiv','ExBeforeFutureDiv','ExAfterFutureDiv','ExDivCall','ExAskSoon','ExAskNow','ExSurfSoon','ExSurfNow','ExBidSoon','ExBidNow') NOT NULL DEFAULT 'None',
    `numExecutions` INT NOT NULL DEFAULT 0 COMMENT 'number of included SpdrParentExecution records',
    `maxExecDttm` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'maximum activity dttm of execution records included in this option risk summary',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    PRIMARY KEY USING HASH (`okey_tk`,`okey_yr`,`okey_mn`,`okey_dy`,`okey_xx`,`okey_cp`,`okey_at`,`okey_ts`,`accnt`,`tradeDate`,`riskSession`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='OptionPositionRecords are live risk records that contain start-of-day positions and all subsequent executions, including executions reported as done away.\nThese records are published by a CoreRiskServer and represent the position and risk markup detail for a single option series.\nNew records are published immediately when a position changes and about once per minute if no position has changed.\nNote that all records for a single underlier are published simultaneously and records for the same chain should have consistent marks.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `okey_at`,
    `okey_ts`,
    `okey_tk`,
    `okey_yr`,
    `okey_mn`,
    `okey_dy`,
    `okey_xx`,
    `okey_cp`,
    `accnt`,
    `tradeDate`,
    `riskSession`,
    `clientFirm`,
    `riskServerCode`,
    `aggGroup`,
    `fkey_at`,
    `fkey_ts`,
    `fkey_tk`,
    `fkey_yr`,
    `fkey_mn`,
    `fkey_dy`,
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `exType`,
    `multihedge`,
    `multihedgeSource_at`,
    `multihedgeSource_ts`,
    `multihedgeSource_tk`,
    `multihedgePVRatio`,
    `optionType`,
    `cashOnEx`,
    `strikeRatio`,
    `uPrcRatio`,
    `underliersPerCn`,
    `underlierType`,
    `tickValue`,
    `pointValue`,
    `pointCurrency`,
    `priceFormat`,
    `uPriceFormat`,
    `uPrc`,
    `uBid`,
    `uAsk`,
    `uMark`,
    `uMarkSource`,
    `optBid`,
    `optAsk`,
    `optMidMark`,
    `optVolMark`,
    `uOpnMark`,
    `optOpnVolMark`,
    `optOpnMidMark`,
    `optOpnClrMark`,
    `optOpnPosPrv`,
    `optOpnPosClr`,
    `optOpnPos`,
    `optOpnPosSrc`,
    `cnBot`,
    `cnSld`,
    `cnOpened`,
    `cnClosed`,
    `edgeOpened`,
    `edgeClosed`,
    `trdDelta`,
    `trdGamma`,
    `trdDeltaMny`,
    `optMnyBot`,
    `optMnySld`,
    `dayPnl`,
    `dnDayPnl`,
    `opnPnlMidMark`,
    `opnPnlVolMark`,
    `opnPnlClrMark`,
    `cnNetOpnPos`,
    `cnNetCurPos`,
    `cnAtmEquiv`,
    `beta`,
    `betaSource`,
    `divDays`,
    `hedgeDeltaRule`,
    `binaryDays`,
    `days`,
    `years`,
    `rate`,
    `sdiv`,
    `ddiv`,
    `dadj`,
    `atmVol`,
    `atmVega`,
    `iVol`,
    `iVolSrc`,
    `de`,
    `ga`,
    `th`,
    `ve`,
    `rh`,
    `ph`,
    `vo`,
    `va`,
    `deDecay`,
    `err`,
    `veSlope`,
    `hedgeDe`,
    `hedgeGa`,
    `srSlope`,
    `isBinary`,
    `premOvPar`,
    `xde`,
    `loBound`,
    `su90`,
    `sd90`,
    `su50`,
    `sd50`,
    `su15`,
    `sd15`,
    `su10`,
    `sd10`,
    `su06`,
    `sd08`,
    `su05`,
    `sd05`,
    `su1e`,
    `sd1e`,
    `su2e`,
    `sd2e`,
    `earn`,
    `cash`,
    `theoModel`,
    `tVol`,
    `tOpx`,
    `tBOpnPx`,
    `tSOpnPx`,
    `tBClsPx`,
    `tSClsPx`,
    `tDe`,
    `tGa`,
    `tErr`,
    `theoModel2`,
    `tVol2`,
    `tOpx2`,
    `tErr2`,
    `yearsPr`,
    `ratePr`,
    `sdivPr`,
    `ddivPr`,
    `iVolPr`,
    `dePr`,
    `gaPr`,
    `thPr`,
    `vePr`,
    `rhPr`,
    `phPr`,
    `voPr`,
    `vaPr`,
    `errPr`,
    `veSlopePr`,
    `hedgeDePr`,
    `tVolPr`,
    `tOpxPr`,
    `tDePr`,
    `tVolPr2`,
    `tOpxPr2`,
    `tDePr2`,
    `xdePr`,
    `marginUDnVDn`,
    `marginUDnVUp`,
    `marginUUpVDn`,
    `marginUUpVUp`,
    `opnPnlDe`,
    `opnPnlGa`,
    `opnPnlTh`,
    `opnPnlVe`,
    `opnPnlVo`,
    `opnPnlVa`,
    `opnPnlSl`,
    `opnPnlRate`,
    `opnPnlSDiv`,
    `opnPnlDDiv`,
    `opnPnlSv`,
    `opnPnlErr`,
    `shBotC0`,
    `shSldC0`,
    `shMnyC0`,
    `shBotC1`,
    `shSldC1`,
    `shMnyC1`,
    `markErrCodes`,
    `exValue`,
    `riskAlert`,
    `numExecutions`,
    `maxExecDttm`,
    `timestamp`
FROM `SRRisk`.`MsgOptionPositionRecordV5`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `okey_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `okey_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `okey_tk` = 'Example_okey_tk'
  AND
    /* Replace with a SMALLINT UNSIGNED */ 
    `okey_yr` = 123
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `okey_mn` = 1
  AND
    /* Replace with a TINYINT UNSIGNED */ 
    `okey_dy` = 1
  AND
    /* Replace with a DOUBLE */ 
    `okey_xx` = 4.56
  AND
    /* Replace with a ENUM('Call','Put','Pair') */ 
    `okey_cp` = 'Call'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a DATE */
    `tradeDate` = '2022-01-01'
  AND
    /* Replace with a ENUM('Regular','PostClose') */
    `riskSession` = 'Regular'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRRisk.doccolumns WHERE TABLE_NAME='OptionPositionRecordV5' ORDER BY ordinal_position ASC;